Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | RetailStore(PA_STR_RTL) |
StockMeterID (PK) | A unique identifier for the stock meter | ID_MTR_STK | Identity | integer | |
UnitOfMeasureCode (FK) | The code used to specify the units in which a value is being expressed, or manner in which a measurement has been taken. This code relates to the UCC data element 355. | CD_UOM | Code | varchar(20) | UnitOfMeasure(CO_UOM) |
DeviceMeterID | The MeterID the FuelingPoint uses to identify this StockMeter. Cannot use this MeterID as the Primary Key because Meters break and need to be replaced. | ID_MTR_DVC | IdentityAlphaNumeric | varchar(20) | |
StatusCode | A code denoting the status of the StockMeter. Possible values include Active and InActive. | SC_MTR | Code2Status | char(2) | |